package cn.by.wms.dao;

import java.util.List;

import cn.smart.core.annotation.PageX;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import cn.by.wms.entity.*;
import org.apache.ibatis.annotations.Update;

/**
 * 库存表;(206_inventory)表数据库访问层
 * @author : heimi
 * @date : 2024-11-29
 */
@Mapper
public interface InventoryDao {
 
    @PageX
    List<Inventory> select(InventoryQuery query);
    Integer insert(Inventory inventory);
    Integer insertBatch(@Param("inventorys")List<Inventory> inventorys);
    Integer update(Inventory inventory);
    Integer delete(Integer id);

    Integer updateQty( @Param("optionQty")int optionQty,  @Param("productId")int productId, @Param("version")int version);
 
}